from app import db

class NormalLog(db.Model):
    __tablename__ = 'normal_log'

    id = db.Column(db.Integer, primary_key=True)
    uid = db.Column(db.BigInteger, nullable=False, index=True)
    referer_url = db.Column(db.String(255))
    target_url = db.Column(db.String(255), nullable=False)
    query_params = db.Column(db.Text)
    ua = db.Column(db.String(255), nullable=False)
    ip = db.Column(db.String(32), nullable=False)
    created_time = db.Column(db.DateTime, nullable=False)
